Click F3
Move your mouse cursor to the lower left-hand corner of F3.
Drag the fill handle from F3 to F8.
Release your left mouse button.
|
Excel will display a shaded border around the data range.
Click the AutoSum button 
Excel will calculates the appropriate relative totals for each cell.
Your spreadsheet should now look like the one below:
 |
Now your turn! Try it!